Overview

Dataset Statistics

Number of Variables 10
Number of Rows 3921
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 516.9 KB
Average Row Size in Memory 135.0 B
Variable Types
  • Numerical: 5
  • Categorical: 5

Dataset Insights

CustomerID is skewed Skewed
Recency is skewed Skewed
Frequency is skewed Skewed
Monetary is skewed Skewed
RFMScoreGroup is skewed Skewed
R has constant length 1 Constant Length
F has constant length 1 Constant Length
M has constant length 1 Constant Length
RFMScore has constant length 1 Constant Length

Variables

CustomerID

numerical

Approximate Distinct Count 3921
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 61.3 KB
Mean 15561.4716
Minimum 12346
Maximum 18287
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • CustomerID is skewed left (γ1 = -0.0112)

Quantile Statistics

Minimum 12346
5-th Percentile 13094
Q1 14208
Median 15569
Q3 16913
95-th Percentile 18015
Maximum 18287
Range 5941
IQR 2705

Descriptive Statistics

Mean 15561.4716
Standard Deviation 1576.8237
Variance 2.4864e+06
Sum 6.1017e+07
Skewness -0.0112
Kurtosis -1.1861
Coefficient of Variation 0.1013
  • CustomerID is not normally distributed (p-value 1.3133795372136564e-11)

Recency

numerical

Approximate Distinct Count 302
Approximate Unique (%) 7.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 61.3 KB
Mean 92.7223
Minimum 1
Maximum 374
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Recency is skewed right (γ1 = 1.2449)

Quantile Statistics

Minimum 1
5-th Percentile 3
Q1 18
Median 51
Q3 143
95-th Percentile 311
Maximum 374
Range 373
IQR 125

Descriptive Statistics

Mean 92.7223
Standard Deviation 99.5285
Variance 9905.9287
Sum 363564
Skewness 1.2449
Kurtosis 0.4407
Coefficient of Variation 1.0734
  • Recency is not normally distributed (p-value 5.339987994502053e-10)
  • Recency has 133 outliers

Frequency

numerical

Approximate Distinct Count 443
Approximate Unique (%) 11.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 61.3 KB
Mean 90.3711
Minimum 1
Maximum 7847
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Frequency is skewed right (γ1 = 18.662)

Quantile Statistics

Minimum 1
5-th Percentile 4
Q1 17
Median 41
Q3 99
95-th Percentile 314
Maximum 7847
Range 7846
IQR 82

Descriptive Statistics

Mean 90.3711
Standard Deviation 217.7962
Variance 47435.1651
Sum 354345
Skewness 18.662
Kurtosis 539.721
Coefficient of Variation 2.41
  • Frequency is not normally distributed (p-value 8.254055545115564e-25)
  • Frequency has 343 outliers

Monetary

numerical

Approximate Distinct Count 3856
Approximate Unique (%) 98.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 61.3 KB
Mean 1863.9101
Minimum 0
Maximum 259657.3
Zeros 1
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Monetary is skewed right (γ1 = 20.193)

Quantile Statistics

Minimum 0
5-th Percentile 110.75
Q1 300.04
Median 651.82
Q3 1575.89
95-th Percentile 5493.46
Maximum 259657.3
Range 259657.3
IQR 1275.85

Descriptive Statistics

Mean 1863.9101
Standard Deviation 7481.9222
Variance 5.5979e+07
Sum 7.3084e+06
Skewness 20.193
Kurtosis 553.414
Coefficient of Variation 4.0141
  • Monetary is not normally distributed (p-value 4.534341396753723e-25)
  • Monetary has 382 outliers

R

categorical

Approximate Distinct Count 3
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 252.7 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 1
2nd row 1
3rd row 1
4th row 1
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3921
  • The top 2 categories (2, 3) take over 50.0%
  • R has words of constant length

F

categorical

Approximate Distinct Count 3
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 252.7 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 1
2nd row 1
3rd row 1
4th row 1
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3921
  • The top 2 categories (2, 1) take over 50.0%
  • F has words of constant length

M

categorical

Approximate Distinct Count 3
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 252.7 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 1
2nd row 1
3rd row 1
4th row 1
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3921
  • The top 2 categories (1, 2) take over 50.0%
  • M has words of constant length

RFMScore

categorical

Approximate Distinct Count 7
Approximate Unique (%) 0.2%
Missing 0
Missing (%) 0.0%
Memory Size 252.7 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 3
2nd row 3
3rd row 3
4th row 3
5th row 3

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3921
  • RFMScore has words of constant length

RFMScoreGroup

numerical

Approximate Distinct Count 27
Approximate Unique (%) 0.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 61.3 KB
Mean 240.9199
Minimum 111
Maximum 333
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • RFMScoreGroup is skewed left (γ1 = -0.3375)

Quantile Statistics

Minimum 111
5-th Percentile 111
Q1 211
Median 222
Q3 322
95-th Percentile 333
Maximum 333
Range 222
IQR 111

Descriptive Statistics

Mean 240.9199
Standard Deviation 77.6854
Variance 6035.015
Sum 944647
Skewness -0.3375
Kurtosis -1.1211
Coefficient of Variation 0.3225
  • RFMScoreGroup is not normally distributed (p-value 3.471185944107563e-10)

Loyalty

categorical

Approximate Distinct Count 3
Approximate Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 271.7 KB

Length

Mean 5.948
Standard Deviation 1.5693
Median 6
Minimum 4
Maximum 8

Sample

1st row Platinum
2nd row Platinum
3rd row Platinum
4th row Platinum
5th row Platinum

Letter

Count 23322
Lowercase Letter 19401
Space Separator 0
Uppercase Letter 3921
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Silver, Gold) take over 50.0%

Interactions

Correlations

Missing Values